﻿using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Configuration;

namespace Entity
{
    public class SMDBContext : DbContext
    {


        public SMDBContext(DbContextOptions<SMDBContext> opts) : base(opts)
        {

        }



        /// <summary>
        /// 账户
        /// </summary>
        //public DbSet<Account> Accounts { get; set; }

        /// <summary>
        /// 用户信息
        /// </summary>
        public DbSet<User> user { get; set; }

        ///// <summary>
        ///// 报名表
        ///// </summary>
        //public DbSet<EnrollTable> EnrollTables { get; set; }
        //protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        //{
        //    optionsBuilder.UseMySql("", new MySqlServerVersion(new Version(9, 2, 0)));
        //}

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            User user1 = new User();
            user1.Name = "xiamuo";
            user1.Age = 34;

            modelBuilder.Entity<User>().HasData([

                new User {
                    Name="zhangsan",
                    Age=35,
                    Email="4444sdfsdf@sdf.cvf"
                },
                new User{

                }
            ]);

        }

    }
    public class SMDBContextFactory : IDbContextFactory<SMDBContext>
    {


        public SMDBContext CreateDbContext()
        {
            var optionBuilder = new DbContextOptionsBuilder<SMDBContext>();
            optionBuilder.UseMySql(
                "server=localhost;userid=root;password=123456;database=AIYDB;port=3306;",
                new MySqlServerVersion(new Version(8, 0, 41))
                );
            return new SMDBContext(optionBuilder.Options);
        }
    }
} 

